* OPEN STATA OUTPUT FILE LOG *

log using "C:\Users\gk57526\Dropbox\DISCRIMINATION PROJECT (U.S. FEDERAL AGENCIES)\Organizational Diversity & Formal Complaints Project\Statistics\Krause & Park.Authority Differentials.APPENDIX J RESULTS.11-24-2023.smcl", replace  

  
  

**** "STATUS GROUP DIFFERENTIALS AS REFERENCE POINTS FOR FOSTERING DIVERSITY AND INCLUSION WITHIN THE U.S. FEDERAL CIVILIAN WORKFORCE" [KRAUSE & PARK, NOVEMBER 2023] ****



**** APPENDIX J: EVALUATING POTENTIAL SOCIAL DESIRABILITY BIAS IN EMPLOYEE RESPONDENT D & I EVALUATIONS ***




*** ACCESS DATABASE FOR THE PROJECT: FEVS DATA FROM 2010-2019 AND 'MATCHED' OPM DATA: POST-ESTIMATION OF MANUSCRIPT RESULTS ****


use "C:\Users\gk57526\Dropbox\DISCRIMINATION PROJECT (U.S. FEDERAL AGENCIES)\Organizational Diversity & Formal Complaints Project\Statistics\2010-2019_DATA FINAL.11-22-2023.GAK.post-estimation.dta", replace   

 
******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
*****************************************************************************************************************************************************************************************




****** DIFFERENCES IN MEANS (T) TEST *******

*** TERCILE GROUPINGS BASED ON EFFECTIVE SAMPLE OF OPBSERVATIONS COVERED IN THE REGRESSION MODELS [N = 2,507,103] ***



quietly regress lndiversity2zeroadj  c.ln_ratio_fmsup_fmsub##i.gender   ln_ratio_fem_tot_men_tot   minority  supervisor  topoffgender_2 lntotworkforce_count  ln_professionals_total_ratio i.agencyid i.year , vce(cluster agencyid)
*
estat ic
*
*
*

_pctile  ln_ratio_fmsup_fmsub if e(sample), p(33.33, 66.67)
return list
*
_pctile  ln_ratio_mnmsup_mnmsub if e(sample), p(33.33, 66.67)
return list


******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




*** WOMEN versus MEN Respondent Differences: Relative SGPDs [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)] ***


** LOWER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub < -0.4131458103656769] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub < -0.4131458103656769, by(gender) unequal reverse

** MIDDLE TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431, by(gender) unequal reverse

** UPPER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.2619786560535431] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.2619786560535431, by(gender) unequal reverse




************** BROKEN DOWN BY NON-SUPERVISORY RESPONDENTS AND SUPERVISORY RESPONDENTS **************



************** NON-SUPERVISORY RESPONDENTS **************


** LOWER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub < -0.4131458103656769] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub < -0.4131458103656769 & supervisor == 0, by(gender) unequal reverse

** MIDDLE TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431 & supervisor == 0, by(gender) unequal reverse

** UPPER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.2619786560535431] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.2619786560535431 & supervisor == 0, by(gender) unequal reverse




************** SUPERVISOR RESPONDENTS **************


** LOWER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub < -0.4131458103656769] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub < -0.4131458103656769 & supervisor == 1, by(gender) unequal reverse

** MIDDLE TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431 & supervisor == 1, by(gender) unequal reverse

** UPPER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.2619786560535431] ** 
ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.2619786560535431 & supervisor == 1, by(gender) unequal reverse










*** RACIAL/ETHNIC MINORITY versus RACIAL/ETHNIC NON-MINORITY Respondent Differences: Relative SGPDs  [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)] ***

** LOWER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub < -0.3859817981719971] ** 
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub < -0.3859817981719971, by(minority) unequal reverse

** MIDDLE TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443] ** 
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443, by(minority) unequal reverse

** UPPER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.286034494638443] **
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.286034494638443, by(minority) unequal  reverse





************** BROKEN DOWN BY NON-SUPERVISORY RESPONDENTS AND SUPERVISORY RESPONDENTS **************




************** NON-SUPERVISORY RESPONDENTS **************


*** RACIAL/ETHNIC MINORITY versus RACIAL/ETHNIC NON-MINORITY Respondent Differences: Relative SGPDs  [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)]***



** LOWER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub < -0.3859817981719971] ** 
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub < -0.3859817981719971 & supervisor == 0, by(minority) unequal  reverse

** MIDDLE TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -.3838399 & ln_ratio_mnmsup_mnmsub < -0.286034494638443] ** 
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443 & supervisor == 0, by(minority) unequal  reverse

** UPPER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.286034494638443] **
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.286034494638443 & supervisor == 0, by(minority) unequal  reverse




************** SUPERVISOR RESPONDENTS **************



*** RACIAL/ETHNIC MINORITY versus RACIAL/ETHNIC NON-MINORITY Respondent Differences: Relative SGPDs [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)]***


** LOWER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub < -0.3859817981719971] ** 
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub < -0.3859817981719971 & supervisor == 1, by(minority) unequal  reverse

** MIDDLE TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443] ** 
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443 & supervisor == 1, by(minority) unequal  reverse

** UPPER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.286034494638443] **
ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.286034494638443 & supervisor == 1, by(minority) unequal  reverse




************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************


log close
